UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzTwMnOuDT3DQEMtxZjK4RRLccBw1S0yW57rvt7MLSs='
WHERE
key_id = '5689f73f357ca0cea8bf1c42c06509cd3d172e70b489835e835ec765481cb813'
AND (
token = 'VzTwMnOuDT3DQEMtxZjK4RRLccBw1S0yW57rvt7MLSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)