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