UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8yKJneO+SCoQ3f7JABRhzaf3CyEXk/RnXcoMx0Ckak='
WHERE
key_id = 'ed4be601d0eb2bfcb1b1be217a767b7d8d035dfde6e65107362359472a78bce7'
AND (
token = 'W8yKJneO+SCoQ3f7JABRhzaf3CyEXk/RnXcoMx0Ckak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)