UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dF7eiS2MbLfabW1zSCFOvz5BTTF+J2rTA8YHWOyO48='
WHERE
key_id = '27c45bcbc12515272277518aadd80dd1ebf298a68f689990b94dcf91f3c25d58'
AND (
token = '8dF7eiS2MbLfabW1zSCFOvz5BTTF+J2rTA8YHWOyO48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)