UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKPnT5W1AxJzaO/Ph1wQuW/AONJN11OSjQuARly5Wow='
WHERE
key_id = '8670f983d06e90dc852616f0490350f2c726d8bad91a2168426f2ebc78f0c145'
AND (
token = 'ZKPnT5W1AxJzaO/Ph1wQuW/AONJN11OSjQuARly5Wow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)