UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gX5Wes9TlNGCCFuAiBHCsGLAuafPHDLKwZHYhTmH2Lo='
WHERE
key_id = 'fb5d56d1833e96a6bb8e921441287fa668ba66b6b734f82061471161d67d2416'
AND (
token = 'gX5Wes9TlNGCCFuAiBHCsGLAuafPHDLKwZHYhTmH2Lo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)