UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F1tkUBOKjzpDZ+/EHu8YziG9YxW16cHiwCq+0urYshc='
WHERE
key_id = 'eba8de37785da0bf036b4ad42ded933fe34559479716148f6859d7f2d8117893'
AND (
token = 'F1tkUBOKjzpDZ+/EHu8YziG9YxW16cHiwCq+0urYshc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)