UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnma/5tILyLGpatFCg15c0pzkWNcZ6/eR8Ry+00j5Gc='
WHERE
key_id = '14607f7cbf7863fc4005baefd9ba1af3be6f178fb2428b0cce21fc758ef78903'
AND (
token = 'pnma/5tILyLGpatFCg15c0pzkWNcZ6/eR8Ry+00j5Gc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)