UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8lDG5pXlBitoJazVjqb72bxWLyu01zw971I6heJ3IYo='
WHERE
key_id = 'd874290c6381124c4209a492770f8fcdcb176dc8c8c0152557b64867cc69e046'
AND (
token = '8lDG5pXlBitoJazVjqb72bxWLyu01zw971I6heJ3IYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)