UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49HHOfRVdEk8eEsf6A46Cw2SBT4FNe6bJhar9/nRDt4='
WHERE
key_id = '6ef2c42162e5207e5ace2e33c583dd8721b4c5ff38844eaf8ccf41a2c51a6f2a'
AND (
token = '49HHOfRVdEk8eEsf6A46Cw2SBT4FNe6bJhar9/nRDt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)