UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zzoCVx96ctVD+guCFSRf7O7HpyqJ9K8YVDF7PO/w52A='
WHERE
key_id = '2689bef99914dc799d1437a013fd6e5ed878482406c15ebd342f09566cfcba50'
AND (
token = 'zzoCVx96ctVD+guCFSRf7O7HpyqJ9K8YVDF7PO/w52A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)