UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9J7sa+etkDdjcVHsKubVKptTfolqS6diKyDgVj1/o8='
WHERE
key_id = '418224d47e22170f4162161ff2f8bd4c86173204177da5a97b85a70da0783ca9'
AND (
token = 'n9J7sa+etkDdjcVHsKubVKptTfolqS6diKyDgVj1/o8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)