UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '24gM7df/4duGRhhUniurkVj0Xy8Czeaw3g8NRsVCyAA='
WHERE
key_id = 'aa32a22736e820aebc5f0604b2859e2e44cdeb0147d4899a39b23a5301f94dc5'
AND (
token = '24gM7df/4duGRhhUniurkVj0Xy8Czeaw3g8NRsVCyAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)