UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WFdIjE4F1eP4iWfdlkqH7Zrk/vgKOs3syYYNuLy2208='
WHERE
key_id = 'bb65a8d2feeafbbe715acd484f0bf92f47b2225a96b0e037036cc270e65d8119'
AND (
token = 'WFdIjE4F1eP4iWfdlkqH7Zrk/vgKOs3syYYNuLy2208='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)