UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3YrzNoWz53IldLHV+AuyAk9Pl9auvVPRxjGEC8aNBI8='
WHERE
key_id = 'd0a5ded6c9439488dd948b09835e88e6551a64e772e0f4b2174eb5e132039c11'
AND (
token = '3YrzNoWz53IldLHV+AuyAk9Pl9auvVPRxjGEC8aNBI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)