UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MVcNkMlgqHaG9YUxrpV4iUeZMdUufSsp8Al6OGIJfsI='
WHERE
key_id = '0fbe46b98d2a2fc0a36ac649efd2e97e01947a3afa7bf3cdf6d7717528c660d0'
AND (
token = 'MVcNkMlgqHaG9YUxrpV4iUeZMdUufSsp8Al6OGIJfsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)