UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dprHioijEJwAsP60QvTkQOs0FDnbrs2dXS+1jTKtkBk='
WHERE
key_id = '412c980a8b089905314642570bc1d1f68443095705d1accd3f913b7c9518a2d1'
AND (
token = 'dprHioijEJwAsP60QvTkQOs0FDnbrs2dXS+1jTKtkBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)