UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LxKnCFfxF3CMzEEx1gGeJzDAEzxyzSz3Nvn3J7/DFEM='
WHERE
key_id = '9cb926ece994901182d8a1f8bb03fd89ad1386c29cae9c3718213523570a097a'
AND (
token = 'LxKnCFfxF3CMzEEx1gGeJzDAEzxyzSz3Nvn3J7/DFEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)