UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1SGt8jmL8RdyPow27hVBoCRoCJPuDFoXHi1+sc4GZW4='
WHERE
key_id = 'd8c7e741e4005e14cedf0f3bcea8e38e109292e49fe47f877a2f727176f9072b'
AND (
token = '1SGt8jmL8RdyPow27hVBoCRoCJPuDFoXHi1+sc4GZW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)