UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHb0FZQFptK17J7lNAsUqlG7P2emUcVEecPfPlFtZfI='
WHERE
key_id = 'ff8805633443bd668b80b447007e059baab2942ad9c917f7d0893a3a51bc68e6'
AND (
token = 'pHb0FZQFptK17J7lNAsUqlG7P2emUcVEecPfPlFtZfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)