UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3YHGYaOqqAb6sOt7rrhFfhkPZhTHArDc2QfjpIH0o6A='
WHERE
key_id = '3eac66b9db9546442b92169a147bfd68977800990ba7050aeb7d45da9f5a9490'
AND (
token = '3YHGYaOqqAb6sOt7rrhFfhkPZhTHArDc2QfjpIH0o6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)