UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JRNweNSd787YXOkwWSW8zzD9DtS98hgDzO1RhyA7ay8='
WHERE
key_id = '2d9c851e06cd5f5ad59e7fbcdd009ef7aaeb0c56fc6c0f8ed54c7d25cbdd864d'
AND (
token = 'JRNweNSd787YXOkwWSW8zzD9DtS98hgDzO1RhyA7ay8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)