UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zlKnoUH7gNc9qN2+oCzVabYRB2T33vPz/Gtd6MqLBcA='
WHERE
key_id = '738383a8462858ab26a314da0dd5c30c54f959b06c1861d24dfc78e058f54b55'
AND (
token = 'zlKnoUH7gNc9qN2+oCzVabYRB2T33vPz/Gtd6MqLBcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)