UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9jC5v2lDde1d8Ry5JNvw/mpeaqhNsJKlU5iLA40db8='
WHERE
key_id = '02e6ff5e0f3ac032fd42dd11625295b1a4fc978830486e8bc971240423c6a45c'
AND (
token = 'X9jC5v2lDde1d8Ry5JNvw/mpeaqhNsJKlU5iLA40db8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)