UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ch1bJEyIZzhTiud18hTxP1JSQ8k/rrudjV1hZ7XqBks='
WHERE
key_id = 'c1f4e2620e80c058456002148a05eb3584dd639774ce7efe7feefe286149876c'
AND (
token = 'ch1bJEyIZzhTiud18hTxP1JSQ8k/rrudjV1hZ7XqBks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)