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