UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vDl9hvSRrDf+30wvVkQJmJqv8v7UURIZVDvoxBjWxpU='
WHERE
key_id = 'aa19ae1dd9a1732b043ea5f1d9e8cc67e21851a7d79fce9c2d086174b4ab9a71'
AND (
token = 'vDl9hvSRrDf+30wvVkQJmJqv8v7UURIZVDvoxBjWxpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)