UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o7CyTWJfx6eFU9OkN4NpKEumpG9CTM7Zn02Mxi8zXSo='
WHERE
key_id = '7508e218f554bf3469a7de5a3362584568ee78c212b9ee57314dc17fd12ca596'
AND (
token = 'o7CyTWJfx6eFU9OkN4NpKEumpG9CTM7Zn02Mxi8zXSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)