UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cA358cfSkJF73URC6ZuECkmGxH26mSfQhVKgeNfWkn0='
WHERE
key_id = '1f886757742e5b3a53a0356b0ee29cd5425f0b068ad270a9ebbdd0e69d216cae'
AND (
token = 'cA358cfSkJF73URC6ZuECkmGxH26mSfQhVKgeNfWkn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)