UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sE7CPiq821Md8sJlKAMpoWHxj4B4RDfFEMw5qYtL9W8='
WHERE
key_id = 'd8aee8a6b107f49beca936471d737e6d3b6516d788c93ae572bb0a2b2304f4c5'
AND (
token = 'sE7CPiq821Md8sJlKAMpoWHxj4B4RDfFEMw5qYtL9W8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)