UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zh/+XghBYhQgLSlZigPcvayCA4l7PrB/vXizkLT5kFM='
WHERE
key_id = 'beef8966d15128028a91df87d7edc09a5ec07aa2ed31afdb2d03fc04da7abc1a'
AND (
token = 'Zh/+XghBYhQgLSlZigPcvayCA4l7PrB/vXizkLT5kFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)