UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CQw4CJ2jEOXE+h+8Qrh6524RnKFf86n5LFv7F1g5jvc='
WHERE
key_id = 'a1504075e24cdb454f36fe82fbd37f04d3f301c2394338a47fccc43e3e8a22e6'
AND (
token = 'CQw4CJ2jEOXE+h+8Qrh6524RnKFf86n5LFv7F1g5jvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)