UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OBYZtZwOn+NWPiNcXfBovijISCmaGPaxqf4K8yH87F4='
WHERE
key_id = '8a4e48b9fc761ddf62762b542a1cdb97046dbe543ae8c2c395147885d5f7895a'
AND (
token = 'OBYZtZwOn+NWPiNcXfBovijISCmaGPaxqf4K8yH87F4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)