UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pn+qRMi7cplJXd+2I7fgDNNbODNAIPUW5eXvwzfeF2w='
WHERE
key_id = '6988b0ab41b939473b36f6fcce5f9ac99f27c21cc9f8eb43c6362a2a08fb50b4'
AND (
token = 'pn+qRMi7cplJXd+2I7fgDNNbODNAIPUW5eXvwzfeF2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)