UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aJ1za7X7NPrGrYogHshtc63ZeUWcV5nRvVVI4maX6AI='
WHERE
key_id = '87eb8e500682b33ca36fa71159d009651aa4e96cc3d5b2973b91de7d49346b4c'
AND (
token = 'aJ1za7X7NPrGrYogHshtc63ZeUWcV5nRvVVI4maX6AI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)