UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tNVJ4pgxRld5ho58eVAdZy/xPty1xyL4VLI28Wn5IKI='
WHERE
key_id = 'f249855a4f245e8bcaecd7f49bf413343b28a3022b28859084948b6ea445c260'
AND (
token = 'tNVJ4pgxRld5ho58eVAdZy/xPty1xyL4VLI28Wn5IKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)