UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YgQoeWaJBvpCI4geWiJKy6YBVh8/3Ds2t+86D1jG1nc='
WHERE
key_id = 'e2a711dc2a4a9937d3c3f66f281699a95c6380ef724cf4ef13c04afbafdbb8ed'
AND (
token = 'YgQoeWaJBvpCI4geWiJKy6YBVh8/3Ds2t+86D1jG1nc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)