UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BFTiBtsIZXZHFls59J+0KK/BFSbqgC/30I3foC2CyXc='
WHERE
key_id = 'e8093d49404a8e309acaf301956dd001f47a643fb7231c671536eeb5212e54ef'
AND (
token = 'BFTiBtsIZXZHFls59J+0KK/BFSbqgC/30I3foC2CyXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)