UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gpLHQJsaBFjnhxZCzhfQoJeLeyJ7VR3ZALJ2y9q5koA='
WHERE
key_id = '138c6dfa218c50e0b5ea1238071f30feea9db772fb31c48e254bb56f4807cd6b'
AND (
token = 'gpLHQJsaBFjnhxZCzhfQoJeLeyJ7VR3ZALJ2y9q5koA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)