UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cS1xlKbLdpRhfCbWWCfBky3LnKhCBD9YWELqYNvpIx8='
WHERE
key_id = 'e12e5739a35fb4ee984c82a663e5d9dc117be694663707f48cc99ed61f64d79d'
AND (
token = 'cS1xlKbLdpRhfCbWWCfBky3LnKhCBD9YWELqYNvpIx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)