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